Visual Spreadsheet Upload
On this page
The visual spreadsheet upload is a module for the non-technical user or the user that don't want to write a custom data loader. The concept is simple: by visually selecting the spreadsheet columns for entity fields, an arbitrary spreadsheet, e.g. spreadsheets generated by instruments, can be used for data upload.
Video
The following video shows a prototype of this concept:
Description
- A spreadsheet named
DNA sequences.xlsxcontains DNA sequences which can be saved as BioSequences. - The Entity Class BioSequence is chosen and the file is dropped on the dropzone.
- The fields are chosen, and one row appears [0:21].
- Three rows are chosen for Name, and the option Continue to last row are chosen for Description and SeqData.
- Now three rows appears [0:35], but Status and Type are only shown for the first row, Single value for all are chosen for these to use the same value for all rows.
- When Upload is clicked, the resulting entities are shown.